# pip install bottle
# dbvis ## запуск DBVisualizer

import sqlite3
from bottle import route, run, template

@route('/pato/meddb')
def show_anomal():
	db = sqlite3.connect('med.db')
	c = db.cursor()
	c.execute("SELECT name, typeColor, diametrPato, typeFluoresc, haveDruz, \
		whattypeDruz, whatsizeDruz, pigmentPato, havePict FROM Pato")
	data = c.fetchall()
	c.close()
	output = template('bring_to_meddb', rows=data)
	return output

run(host='0.0.0.0', port=8080) #http://0.0.0.0:8080/pato/meddb